﻿<?xml version="1.0" encoding="utf-8" ?>
<dataBase connectionName="RuandaoConnection">


  <delete table="MultitagContent" />
  <delete table="Content"/>
  <delete table="Multitag" />
  <delete table="ContentTags" />
  <delete table="Tag"/>
  <delete table="TagContext"/>

  <!-- Task表数据 -->

  <!-- 插入不含非空image字段的记录，isInsertIdentity=content.txt时使用SET IDENTITY_INSERT 开关。 -->

  <insert table="TagContext"  columns="TagContextId,GroupName,OwnerIdentity">
    <values>
      <text>1,'aaa','aa'</text>      
    </values>
  </insert>
  <insert table="Tag" columns="TagId,TagContextId,TagName,Description">
    <values> 
      <text>1,1,'a','aa'</text>
    </values>
    <values>
      <text>2,1,'b','bb'</text>
    </values>
    <values>
      <text>3,1,'c','cc'</text>
    </values>
    <values>
      <text>4,1,'d','dd'</text>
    </values>
    <values>
      <text>5,1,'e','ee'</text>
    </values>
  </insert>
  <insert table="ContentTags" columns="TagContextId,ContentId,TagIdsBinary,TagCount">
    <values>
      <text>1,1,0x00,1</text>
    </values>    
  </insert>
  <insert table="Multitag" columns="MultitagId,TagContextId,TagNumber,TagId0,TagId1,TagId2,TagId3,TagId4,AccessCounter,LastAccessTime,ContentAmount,CachedContentIdsBinary,CachedSubTags,CacheIsOld,OrderBy">
    <values>
      <text>1,1,5,1,0,0,0,0,1,'2009-12-30',1,Null,Null,1,Null</text>
    </values>    
  </insert>
  <insert table="Content" columns="ContentId,ProviderName,OriginalId,ContentType,CreateDate,UserGuid,IsPublic,ViewCount,PostCount,StowCount,Text,Title,Brief,Rank,SizeUnit,Size">
    <values>
      <text>1,'aa','bb',NULL,'2009-12-30',NULL,0,NULL,NULL,NULL,NULL,'cc',NULL,NULL,NULL,NULL</text>
    </values>
  </insert>
  <insert table="MultitagContent" columns="MultitagId,ContentId">
    <values>
      <text>1,1</text>
    </values>    
  </insert>

</dataBase>
